<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Restoring an SAP on Oracle Database">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002164609354.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000002164609382">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Restoring an SAP on Oracle Database</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000002164609382"></a><a name="EN-US_TOPIC_0000002164609382"></a>

<h1 class="topictitle1">Restoring an SAP on Oracle Database</h1>
<div><p>This section describes how to restore a backed-up database to the original or a new location.</p>
<div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Shut down the target database.</span><p><p>Press <strong>Win+R</strong>, enter <strong>cmd</strong>, and press <strong>Enter</strong> to open <strong>Command Prompt</strong> on the Windows host where the target database resides. Perform the following steps to shut down the target database:</p>
<ol type="a"><li>Go to the <strong>run</strong> directory created in <a href="en-us_topic_0000002200010101.html#EN-US_TOPIC_0000002200010101__section10539810434">Manually Creating a run Directory and Copying Files to the Directory</a>. Example:<pre class="screen">C:\&gt;cd usr\sap\EH7\SYS\exe\run</pre>
</li><li>Run the following command to shut down the target database:<pre class="screen">brconnect -c force -l E -u <em>userName</em>/<em>passWord</em> -f dbshut -f</pre>
<div class="p"><em>userName</em> and <em>passWord</em> indicate the name and password of the database user created in <a href="en-us_topic_0000002200010101.html#EN-US_TOPIC_0000002200010101__section09572159441">Starting the Database and Creating a Database User</a>. Example:<pre class="screen">brspace -c force -l E -u user1/Huawei123 -f dbshow -c dbstate</pre>
</div>
</li></ol>
</p></li><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000002164609382__en-us_topic_0000002199964685_uicontrol276155912544"><b><span id="EN-US_TOPIC_0000002164609382__en-us_topic_0000002199964685_text87620597549"><strong>Explore</strong></span> &gt; <span id="EN-US_TOPIC_0000002164609382__en-us_topic_0000002199964685_text776125915420"><strong>Copy Data</strong></span> &gt; <span id="EN-US_TOPIC_0000002164609382__en-us_topic_0000002199964685_text177625918547"><strong>Applications</strong></span> &gt; SAP on Oracle</b></span>.</span></li><li><span>Search for copies by database or copy. This section describes how to search for copies by database.</span><p><p>On the <strong>Resources</strong> tab page, locate the database to be restored by database name and then click the name.</p>
</p></li><li><span>On the <span class="uicontrol"><b>Copy Data</b></span> tab page, select the year, month, and day in sequence to search for copies.</span><p><p>If <span><img src="en-us_image_0000002164769154.png"></span> is displayed below a month or date, copies exist in the month or on the day.</p>
</p></li><li><span>Restore data to a specified point in time or using a specific copy.</span><p><ol type="a"><li>Specify a copy or any point in time between two copies for restoration.<ul><li>Specifying a copy for restoration<p><span><img class="eddx" src="en-us_image_0000002164609434.png"></span></p>
</li><li>Specifying a point in time for restoration<p><span><img class="eddx" src="en-us_image_0000002164609442.png"></span></p>
<p>Data can be restored to a specific point in time in the blue part on the timeline. <span><img src="en-us_image_0000002200010189.png"></span> indicates that a copy exists at this point in time. You cannot specify a point in time for restoration if log backup is not performed at the point in time.</p>
</li></ul>
</li></ol><ol type="a" start="2"><li>Restore an SAP on Oracle database to the original or a new location.<ul><li>Restore an SAP on Oracle database to the original location.<ol class="substepthirdol"><li>Set <strong>Restore To</strong> to <span class="uicontrol"><b>Original location</b></span>.</li><li>Enable or disable <strong>Channels</strong>.<p>If this function is disabled, the default number of channels is <strong>1</strong>. If this function is enabled, you can manually set the number of channels.</p>
<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p>The number of channels refers to the number of threads that can copy files at the same time for a restoration job. Each CPU can allocate a thread to execute a restoration job. The number of channels must be less than or equal to the number of CPUs on the host. Set this parameter based on the host CPU usage and number of CPUs.</p>
</div></div>
</li><li>Click <span class="uicontrol"><b>OK</b></span>.</li></ol>
</li><li>Restore an SAP on Oracle database to a new location.<ol class="substepthirdol"><li>Set <strong>Restore To</strong> to <span class="uicontrol"><b>New location</b></span>.</li><li>Set basic parameters for the restoration.<p><a href="#EN-US_TOPIC_0000002164609382__table261702245415">Table 1</a> describes the related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000002164609382__table261702245415"></a><a name="table261702245415"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002164609382__table261702245415" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Parameters of a restoration job</caption><colgroup><col style="width:18.41%"><col style="width:81.58999999999999%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="18.41%" id="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="81.58999999999999%" id="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="18.41%" headers="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.1 "><p>Tag</p>
</td>
<td class="cellrowborder" valign="top" width="81.58999999999999%" headers="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.2 "><p>Name of a tag associated with the resource. You can filter databases by tag.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="18.41%" headers="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.1 "><p>Resources</p>
</td>
<td class="cellrowborder" valign="top" width="81.58999999999999%" headers="mcps1.3.2.2.5.2.2.1.1.2.1.2.2.2.3.1.2 "><p>Name of the resource for restoring a database to a new location.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li>Enable or disable <strong>Channels</strong>.<p>If this function is disabled, the default number of channels is <strong>1</strong>. If this function is enabled, you can manually set the number of channels.</p>
<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p>The number of channels refers to the number of threads that can copy files at the same time for a restoration job. Each CPU can allocate a thread to execute a restoration job. The number of channels must be less than or equal to the number of CPUs on the host. Set this parameter based on the host CPU usage and number of CPUs.</p>
</div></div>
</li><li>Click <span class="uicontrol"><b>OK</b></span>.</li></ol>
</li></ul>
</li></ol>
</p></li><li><span>Click <span class="uicontrol"><b>OK</b></span>.</span></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000002164609354.html">Restoration</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>